package com.gsta.cdn.cdr.mapper;

import com.baomidou.mybatisplus.mapper.BaseMapper;
import com.gsta.cdn.cdr.entity.ServiceTypeRatings;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Component;

import java.util.List;
import java.util.Map;

@Mapper
@Component(value = "serviceTypeRatingsMapper")
public interface ServiceTypeRatingsMapper extends BaseMapper<ServiceTypeRatings> {
    @Select("<script>" +
            "SELECT Date,SP,ServiceType,sum(RequestsNum)  AS count FROM  ServiceTypeRatings${DBDate}" +
            "WHERE Date=#{Date} GROUP BY ServiceType,SP " +
            "LIMIT #{page},#{pageSize} "+
            "</script>")
    List<Map<String, Object>> ServiceTypeCount(@Param("Date") String Date,@Param("DBDate") String DBDate,@Param("page")int page,@Param("pageSize")int pageSize);


    @Select("<script>" +
            "SELECT  Date,SP,ServiceType,Area,sum(RequestsNum)  AS Count FROM(SELECT  Date,SP,a.IP,ServiceType,b.Area,RequestsNum FROM " +
            "(SELECT Date,SP,IP,ServiceType,RequestsNum FROM ServiceTypeRatings${DBDate} WHERE SP=#{SP} AND Date like CONCAT(#{Date},'%') )a " +
            "JOIN " +
            "(SELECT IP,Area FROM HMSInformation WHERE Area=#{Area}) b " +
            "ON a.IP=b.IP) c " +
            "GROUP BY ServiceType,SP,Area,Date " +
            "ORDER BY Date "+
            "LIMIT #{page},#{pageSize} "+
            "</script>")
    List<Map<String, Object>> ServiceTypeCountByArea(@Param("Date") String Date,@Param("SP") String SP,@Param("Area") String Area,@Param("DBDate") String DBDate,@Param("page")int page,@Param("pageSize")int pageSize);

    @Select("<script>" +
            "SELECT COUNT(*) as Total FROM ( "+
            "SELECT  Date,SP,ServiceType,Area,sum(RequestsNum)  AS count FROM(SELECT  Date,SP,a.IP,ServiceType,b.Area,RequestsNum FROM " +
            "(SELECT Date,SP,IP,ServiceType,RequestsNum FROM ServiceTypeRatings${DBDate} WHERE SP=#{SP} AND Date like CONCAT(#{Date},'%') )a " +
            "JOIN " +
            "(SELECT IP,Area FROM HMSInformation WHERE Area=#{Area}) b " +
            "ON a.IP=b.IP) c " +
            "GROUP BY ServiceType,SP,Area,Date " +
            "ORDER BY Date ) s"+
            "</script>")
    int ServiceTypeCountByAreaTotal(@Param("Date") String Date,@Param("SP") String SP,@Param("Area") String Area,@Param("DBDate") String DBDate);

    @Select("<script>" +
            "SELECT  #{Date},SP,Area,ServiceType,ROUND(AVG(Count)) AS Count FROM( "+
            "SELECT  Date,SP,ServiceType,Area,sum(RequestsNum)  AS Count FROM(SELECT  Date,SP,a.IP,ServiceType,b.Area,RequestsNum FROM " +
            "(SELECT Date,SP,IP,ServiceType,RequestsNum FROM ServiceTypeRatings${DBDate} WHERE SP=#{SP} AND Date like CONCAT(#{Date},'%') )a " +
            "JOIN " +
            "(SELECT IP,Area FROM HMSInformation WHERE Area=#{Area}) b " +
            "ON a.IP=b.IP) c " +
            "GROUP BY ServiceType,SP,Area,Date)S " +
            "GROUP BY ServiceType,SP,Area "+
            "</script>")
    List<Map<String, Object>> ServiceTypeCountAvgByArea(@Param("Date") String Date,@Param("SP") String SP,@Param("Area") String Area,@Param("DBDate") String DBDate);

    @Select("<script>" +
            "SELECT  Date,SP,Area,sum(RequestsNum)  AS Count FROM(SELECT  Date,SP,a.IP,b.Area,RequestsNum FROM " +
            "(SELECT Date,SP,IP,RequestsNum FROM ServiceTypeRatings${DBDate} WHERE SP=#{SP} AND Date like CONCAT(#{Date},'%') )a " +
            "JOIN " +
            "(SELECT IP,Area FROM HMSInformation WHERE Area=#{Area}) b " +
            "ON a.IP=b.IP) c " +
            "GROUP BY SP,Area,Date " +
            "ORDER BY Date "+
            "</script>")
    List<Map<String, Object>> ServiceTypeTotalByArea(@Param("Date") String Date,@Param("SP") String SP,@Param("Area") String Area,@Param("DBDate") String DBDate);





    @Select("<script>" +
            "SELECT  Date,SP,ServiceType,PopID,Area,PopName,sum(RequestsNum)  AS  Count FROM(SELECT  Date,SP,a.IP,ServiceType,b.PopID,b.Area,b.PopName,RequestsNum FROM  " +
            "(SELECT Date,SP,IP,ServiceType,RequestsNum FROM ServiceTypeRatings${DBDate} WHERE  Date like CONCAT(#{Date},'%') AND SP =#{SP} )a  " +
            "JOIN " +
            "(SELECT IP,PopID,Area,CASE WHEN PopName like '%省中心%' THEN '省中心' " +
            " WHEN PopName like '%区域%' THEN'区域'  WHEN PopName like '%边缘%' THEN'边缘' " +
            "  ELSE '其他' END PopName  FROM HMSInformation  WHERE PopName !='其他' AND PopID=#{PopID}) b " +
            "ON a.IP=b.IP) c  " +
            "GROUP BY ServiceType,SP,PopID,Date " +
            "ORDER BY Date "+
            "LIMIT #{page},#{pageSize} "+
            "</script>")
    List<Map<String, Object>> ServiceTypeCountByPopID(@Param("Date") String Date,@Param("SP") String SP,@Param("PopID") String PopID,@Param("DBDate") String DBDate,@Param("page")int page,@Param("pageSize")int pageSize);


    @Select("<script>" +
            "SELECT COUNT(*) as Total FROM ( "+
            "SELECT  Date,SP,ServiceType,PopID,Area,sum(RequestsNum)  AS  Count FROM(SELECT  Date,SP,a.IP,ServiceType,b.PopID,b.Area,RequestsNum FROM  " +
            "(SELECT Date,SP,IP,ServiceType,RequestsNum FROM ServiceTypeRatings${DBDate} WHERE  Date like CONCAT(#{Date},'%') AND SP =#{SP} )a  " +
            "JOIN " +
            "(SELECT IP,PopID,Area FROM HMSInformation WHERE PopID=#{PopID} ) b " +
            "ON a.IP=b.IP) c  " +
            "GROUP BY ServiceType,SP,PopID,Date )s " +
            "</script>")
    int ServiceTypeCountByPopIDTotal(@Param("Date") String Date,@Param("SP") String SP,@Param("PopID") String PopID,@Param("DBDate") String DBDate);


    @Select("<script>" +
            "SELECT  Date,SP,PopID,Area,ServiceType,ROUND(AVG(Count)) AS Count FROM( "+
            "SELECT  Date,SP,ServiceType,PopID,Area,sum(RequestsNum)  AS  Count FROM(SELECT  Date,SP,a.IP,ServiceType,b.PopID,b.Area,RequestsNum FROM  " +
            "(SELECT Date,SP,IP,ServiceType,RequestsNum FROM ServiceTypeRatings${DBDate} WHERE  Date like CONCAT(#{Date},'%') AND SP =#{SP} )a  " +
            "JOIN " +
            "(SELECT IP,PopID,Area FROM HMSInformation WHERE PopID=#{PopID}) b " +
            "ON a.IP=b.IP) c  " +
            "GROUP BY ServiceType,SP,PopID,Date )s " +
            "GROUP BY ServiceType,SP,PopID "+
            "</script>")
    List<Map<String, Object>> ServiceTypeCountAvgByPopID(@Param("Date") String Date,@Param("SP") String SP,@Param("PopID") String PopID,@Param("DBDate") String DBDate);

    @Select("<script>" +
            "SELECT  Date,SP,PopID,Area,sum(RequestsNum)  AS  Count FROM(SELECT  Date,SP,a.IP,b.PopID,b.Area,RequestsNum FROM  " +
            "(SELECT Date,SP,IP,RequestsNum FROM ServiceTypeRatings${DBDate} WHERE  Date like CONCAT(#{Date},'%') AND SP =#{SP} )a  " +
            "JOIN " +
            "(SELECT IP,PopID,Area FROM HMSInformation WHERE PopID=#{PopID}) b " +
            "ON a.IP=b.IP) c  " +
            "GROUP BY SP,PopID,Date " +
            "ORDER BY Date "+
            "</script>")
    List<Map<String, Object>> ServiceTypeTotalByPopID(@Param("Date") String Date,@Param("SP") String SP,@Param("PopID") String PopID,@Param("DBDate") String DBDate);




    @Select("<script>" +
            "SELECT  Date,SP,ServiceType,PopName ,sum(RequestsNum)AS count FROM " +
            "(SELECT  Date,SP,a.IP,ServiceType, " +
            "CASE WHEN b.PopName like CONCAT('%',#{PopName},'%') THEN #{PopName} " +
            "END PopName " +
            ",RequestsNum FROM " +
            "((SELECT Date,SP,IP,ServiceType,RequestsNum FROM ServiceTypeRatings${DBDate} WHERE SP=#{SP} AND Date like CONCAT(#{Date},'%') ) a " +
            "JOIN " +
            "(SELECT IP,PopName FROM HMSInformation WHERE PopName like CONCAT('%',#{PopName},'%')) b " +
            "ON a.IP=b.IP) " +
            ") c " +
            " GROUP BY ServiceType,SP,PopName,Date " +
            " ORDER BY Date " +
            "LIMIT #{page},#{pageSize} "+
            "</script>")
    List<Map<String, Object>> ServiceTypeCountByPopName(@Param("Date") String Date,@Param("PopName") String PopName,@Param("SP") String SP,@Param("DBDate") String DBDate,@Param("page")int page,@Param("pageSize")int pageSize);

    @Select("<script>" +
            "SELECT COUNT(*) as Total FROM ( "+
            "SELECT  Date,SP,ServiceType,PopName ,sum(RequestsNum)AS count FROM " +
            "(SELECT  Date,SP,a.IP,ServiceType, " +
            "CASE WHEN b.PopName like CONCAT('%',#{PopName},'%') THEN #{PopName} " +
            "END PopName " +
            ",RequestsNum FROM " +
            "((SELECT Date,SP,IP,ServiceType,RequestsNum FROM ServiceTypeRatings${DBDate} WHERE SP=#{SP} AND Date like CONCAT(#{Date},'%') ) a " +
            "JOIN " +
            "(SELECT IP,PopName FROM HMSInformation WHERE PopName like CONCAT('%',#{PopName},'%')) b " +
            "ON a.IP=b.IP) " +
            ") c " +
            " GROUP BY ServiceType,SP,PopName,Date )d " +
            "</script>")
    int ServiceTypeCountByPopNameTotal(@Param("Date") String Date,@Param("PopName") String PopName,@Param("SP") String SP,@Param("DBDate") String DBDate);


    @Select("<script>" +
            "SELECT  Date,SP,PopName,ServiceType,ROUND(AVG(count)) AS count FROM( "+
            "SELECT  Date,SP,ServiceType,PopName ,sum(RequestsNum)AS count FROM " +
            "(SELECT  Date,SP,a.IP,ServiceType, " +
            "CASE WHEN b.PopName like CONCAT('%',#{PopName},'%') THEN #{PopName} " +
            "END PopName " +
            ",RequestsNum FROM " +
            "((SELECT Date,SP,IP,ServiceType,RequestsNum FROM ServiceTypeRatings${DBDate} WHERE SP=#{SP} AND Date like CONCAT(#{Date},'%') ) a " +
            "JOIN " +
            "(SELECT IP,PopName FROM HMSInformation WHERE PopName like CONCAT('%',#{PopName},'%')) b " +
            "ON a.IP=b.IP) " +
            ") c " +
            " GROUP BY ServiceType,SP,PopName,Date )d " +
            "GROUP BY ServiceType,SP,PopName "+
            "</script>")
    List<Map<String, Object>> ServiceTypeCountAvgByPopName(@Param("Date") String Date,@Param("PopName") String PopName,@Param("SP") String SP,@Param("DBDate") String DBDate);

    @Select("<script>" +
            "SELECT  Date,SP,PopName ,sum(RequestsNum)AS count FROM " +
            "(SELECT  Date,SP,a.IP, " +
            "CASE WHEN b.PopName like CONCAT('%',#{PopName},'%') THEN #{PopName} " +
            "END PopName " +
            ",RequestsNum FROM " +
            "((SELECT Date,SP,IP,RequestsNum FROM ServiceTypeRatings${DBDate} WHERE SP=#{SP} AND Date like CONCAT(#{Date},'%') ) a " +
            "JOIN " +
            "(SELECT IP,PopName FROM HMSInformation WHERE PopName like CONCAT('%',#{PopName},'%')) b " +
            "ON a.IP=b.IP) " +
            ") c " +
            " GROUP BY SP,PopName,Date " +
            " ORDER BY Date " +
            "</script>")
    List<Map<String, Object>> ServiceTypeTotalByPopName(@Param("Date") String Date,@Param("PopName") String PopName,@Param("SP") String SP,@Param("DBDate") String DBDate);




    @Select("<script>" +
            "SELECT  Date,SP,ServiceType,PopName ,sum(RequestsNum)AS count FROM " +
            "(SELECT  Date,SP,a.IP,ServiceType," +
            "CASE WHEN b.PopName like '%省中心%' THEN'省中心' " +
            "WHEN b.PopName like '%区域%' THEN'区域中心' " +
            "WHEN b.PopName like '%边缘%' THEN'边缘' " +
            "ELSE '其他' " +
            "END PopName,RequestsNum FROM " +
            "((SELECT Date,SP,IP,ServiceType,RequestsNum FROM ServiceTypeRatings${DBDate} WHERE Date=#{Date}) a " +
            "JOIN " +
            "(SELECT IP,PopName FROM HMSInformation) b " +
            "ON a.IP=b.IP)) c " +
            " GROUP BY ServiceType,SP,PopName "+
            "LIMIT #{page},#{pageSize} "+
            "</script>")
    List<Map<String, Object>> ServiceTypeCountPopNameGet(@Param("Date") String Date,@Param("DBDate") String DBDate,@Param("page")int page,@Param("pageSize")int pageSize);





    @Select("<script>" +
            "SELECT Date,SP,ServiceType,sum(RequestsNum)  AS Count FROM  ServiceTypeRatings${DBDate} "   +
            "WHERE SP=#{SP} and Date like CONCAT(#{Date},'%') GROUP BY ServiceType,SP,Date " +
            "ORDER BY Date "+
            "LIMIT #{page},#{pageSize} "+
            "</script>")

    List<Map<String, Object>> ServiceTypeCountBySP(@Param("Date") String Date,@Param("SP") String SP,@Param("DBDate") String DBDate,@Param("page")int page,@Param("pageSize")int pageSize);

    @Select("<script>" +
            "SELECT Date,SP,sum(RequestsNum)  AS Count FROM ServiceTypeRatings${DBDate} " +
            "WHERE SP=#{SP} and Date like CONCAT(#{Date},'%') GROUP BY SP,Date " +
            "</script>")
    List<Map<String, Object>> ServiceTypeTotalBySP(@Param("Date") String Date,@Param("SP") String SP,@Param("DBDate") String DBDate);



    @Select("<script>" +
            "SELECT COUNT(*) as Total FROM ( "+
            "SELECT Date,SP,ServiceType,sum(RequestsNum)  AS Count FROM ServiceTypeRatings${DBDate} " +
            "WHERE SP=#{SP} and Date like CONCAT(#{Date},'%') GROUP BY ServiceType,SP,Date )s" +
            "</script>")
    int ServiceTypeCountBySPTotal(@Param("Date") String Date,@Param("SP") String SP,@Param("DBDate") String DBDate);



    @Select("<script>" +
            "SELECT #{Date},SP,ServiceType,ROUND(AVG(count)) AS count FROM " +
            "(SELECT Date,SP,ServiceType,sum(RequestsNum)  AS count FROM ServiceTypeRatings${DBDate} " +
            "WHERE SP=#{SP} and Date LIKE CONCAT(#{Date},'%') " +
            "GROUP BY ServiceType,SP,Date)s " +
            "GROUP BY ServiceType,SP "+
            "LIMIT #{page},#{pageSize} "+
            "</script>")
    List<Map<String, Object>> ServiceTypeCountAvgBySP(@Param("Date") String Date,@Param("SP") String SP,@Param("DBDate") String DBDate,@Param("page")int page,@Param("pageSize")int pageSize);




    @Select("<script>" +
            "SELECT DISTINCT Area FROM  " +
            "(SELECT Date,SP,IP,ServiceType,RequestsNum FROM ServiceTypeRatings${DBDate} WHERE  Date LIKE CONCAT(#{Date},'%') )a " +
            "JOIN " +
            "(SELECT IP,Area FROM HMSInformation ) b " +
            "ON a.IP=b.IP  " +
            "ORDER BY Area "+
            "</script>")
    List<Map<String, Object>> ServiceTypeArea(@Param("Date") String Date,@Param("DBDate") String DBDate);

    @Select("<script>" +
            "SELECT DISTINCT SP FROM  " +
            "(SELECT Date,SP,IP FROM ServiceTypeRatings${DBDate} WHERE  Date LIKE CONCAT(#{Date},'%') )a " +
            "JOIN " +
            "(SELECT IP,Area FROM HMSInformation WHERE Area=#{Area} ) b " +
            "ON a.IP=b.IP  " +
            "</script>")
    List<Map<String, Object>> ServiceTypeAreaSP(@Param("Date") String Date,@Param("Area") String Area,@Param("DBDate") String DBDate);

    @Select("<script>" +
            "SELECT DISTINCT SP FROM  " +
            "(SELECT Date,SP,IP,ServiceType FROM ServiceTypeRatings${DBDate} WHERE  Date LIKE CONCAT(#{Date},'%') )a " +
            "JOIN " +
            "(SELECT IP,PopID FROM HMSInformation WHERE PopID=#{PopID} ) b " +
            "ON a.IP=b.IP  " +
            "</script>")
    List<Map<String, Object>> ServiceTypePopIDSP(@Param("Date") String Date,@Param("PopID") String PopID,@Param("DBDate") String DBDate);


    @Select("<script>" +
            "SELECT COUNT(*) FROM ( " +
            "SELECT date,sp,serviceType,sum(requestsNum)  AS count FROM ServiceTypeRatings${DBDate}" +
            "WHERE date=#{date} " +
            "GROUP BY serviceType,SP) a " +
            "</script>")
    int countSum(String date,@Param("DBDate") String DBDate);

    @Select("<script>" +
            "SELECT DISTINCT PopName FROM  " +
            "(SELECT Date,SP,IP,ServiceType,RequestsNum FROM ServiceTypeRatings${DBDate} WHERE  Date LIKE CONCAT(#{Date},'%') AND SP=#{SP}) a " +
            "JOIN  " +
            "(SELECT IP,Area,CASE WHEN PopName like '%省中心%' THEN '省中心' " +
            " WHEN PopName like '%区域%' THEN '区域' " +
            " WHEN PopName like '%边缘%' THEN '边缘' " +
            " ELSE '其他' " +
            " END PopName  FROM HMSInformation WHERE Area =#{Area} AND PopName!='其他') b " +
            "ON a.IP=b.IP " +
            "ORDER BY PopName " +
            "</script>")
    List<Map<String, Object>> ServiceTypeAreaPopName(@Param("Date") String Date,@Param("Area") String Area,@Param("SP") String SP,@Param("DBDate") String DBDate);


    @Select("<script>" +
            "SELECT  Date,SP,Area,PopName,ServiceType,sum(RequestsNum)  AS count FROM " +
            "(SELECT Date,SP,IP,ServiceType,RequestsNum FROM ServiceTypeRatings${DBDate} WHERE  Date LIKE CONCAT(#{Date},'%') AND SP=#{SP} )a " +
            "JOIN " +
            "(SELECT IP,Area,CASE " +
            "WHEN PopName like CONCAT('%',#{PopName},'%') THEN  #{PopName} END PopName  " +
            "FROM HMSInformation WHERE Area = #{Area} AND PopName like CONCAT('%',#{PopName},'%')) b " +
            "ON a.IP=b.IP " +
            "GROUP BY SP,Area,Date,ServiceType,PopName " +
            "ORDER BY Date "+
            "LIMIT #{page},#{pageSize} "+
            "</script>")
    List<Map<String, Object>> ServiceTypeByAreaAndPopName(@Param("Date") String Date,@Param("Area") String Area
            ,@Param("SP") String SP,@Param("PopName") String PopName,@Param("DBDate") String DBDate,@Param("page")int page,@Param("pageSize")int pageSize);


    @Select("<script>" +
            "SELECT COUNT(*) FROM ( "+
            "SELECT  Date,SP,Area,PopName,ServiceType,sum(RequestsNum)  AS count FROM " +
            "(SELECT Date,SP,IP,ServiceType,RequestsNum FROM ServiceTypeRatings${DBDate} WHERE  Date LIKE CONCAT(#{Date},'%') AND SP=#{SP} )a " +
            "JOIN " +
            "(SELECT IP,Area,CASE " +
            "WHEN PopName like CONCAT('%',#{PopName},'%') THEN  #{PopName} END PopName  " +
            "FROM HMSInformation WHERE Area = #{Area} AND PopName like CONCAT('%',#{PopName},'%')) b " +
            "ON a.IP=b.IP " +
            "GROUP BY SP,Area,Date,ServiceType,PopName  )s "+
            "</script>")
    int ServiceTypeByAreaAndPopNameTotal(@Param("Date") String Date,@Param("Area") String Area
            ,@Param("SP") String SP,@Param("PopName") String PopName,@Param("DBDate") String DBDate);


    @Select("<script>" +
            "SELECT #{Date} AS Date,SP,Area,ServiceType,PopName,ROUND(AVG(Count)) AS Count FROM( "+
            "SELECT  Date,SP,Area,PopName,ServiceType,sum(RequestsNum)  AS count FROM " +
            "(SELECT Date,SP,IP,ServiceType,RequestsNum FROM ServiceTypeRatings${DBDate} WHERE  Date LIKE CONCAT(#{Date},'%') AND SP=#{SP} )a " +
            "JOIN " +
            "(SELECT IP,Area,CASE " +
            "WHEN PopName like CONCAT('%',#{PopName},'%') THEN  #{PopName} END PopName  " +
            "FROM HMSInformation WHERE Area = #{Area} AND PopName like CONCAT('%',#{PopName},'%')) b " +
            "ON a.IP=b.IP " +
            "GROUP BY SP,Area,Date,ServiceType,PopName  )s " +
            "GROUP BY ServiceType,SP,Area,PopName "+
            "</script>")
    List<Map<String, Object>> ServiceTypeAvgByAreaAndPopName(@Param("Date") String Date,@Param("Area") String Area
            ,@Param("SP") String SP,@Param("PopName") String PopName,@Param("DBDate") String DBDate);


    @Select("<script>" +
            "SELECT  Date,SP,Area,PopName,sum(RequestsNum)  AS count FROM " +
            "(SELECT Date,SP,IP,RequestsNum FROM ServiceTypeRatings${DBDate} WHERE  Date LIKE CONCAT(#{Date},'%') AND SP=#{SP} )a " +
            "JOIN " +
            "(SELECT IP,Area,CASE " +
            "WHEN PopName like CONCAT('%',#{PopName},'%') THEN  #{PopName} END PopName  " +
            "FROM HMSInformation WHERE Area = #{Area} AND PopName like CONCAT('%',#{PopName},'%')) b " +
            "ON a.IP=b.IP " +
            "GROUP BY SP,Area,Date,PopName " +
            "ORDER BY Date "+
            "</script>")
    List<Map<String, Object>> ServiceTypeTotalByAreaAndPopName(@Param("Date") String Date,@Param("Area") String Area
            ,@Param("SP") String SP,@Param("PopName") String PopName,@Param("DBDate") String DBDate);



    @Select("<script>" +
            "SELECT DISTINCT PopID FROM  " +
            "(SELECT Date,SP,IP,ServiceType,RequestsNum FROM ServiceTypeRatings${DBDate} WHERE  Date LIKE CONCAT(#{Date},'%') )a " +
            "JOIN " +
            "(SELECT IP,PopID FROM HMSInformation ) b " +
            "ON a.IP=b.IP  " +
            "GROUP BY RAND() LIMIT 30 "+
            "</script>")
    List<Map<String, Object>> ServiceTypePopID(@Param("Date") String Date,@Param("DBDate") String DBDate);



}
